2013-04-08 - 4257.100 - Rel Notes- ECALC Process rate change DEV-QA #DotNetReleases2013

Release Notes

4257.100 - Payroll Rate Change Procedure(Ver-2)

Admin Info

Purpose
 Payroll Rate Change Procedure(Ver-2)
Release No#
 001
Submitted on
 04/08/2013
Submitted by
 Venkat A
Source/Destination Systems
 NEC DEV\NEC QA
Release Sent To
 Joan Profetta
Objects Created By
 Venkat A
Objects Tested By
 Rajesh K

Transport and Technical Objects

Location Objects Name
\\10.114.165.54\sites\Deployments\BMS POLCA RELEASES\Calc Emb Date Change(D-Q)_04082013\
  • CaluclateEMBRuntype.aspx
  • CaluclateEMBRuntype.aspx.cs
  • Date Change script.sql

Release Notes

For Infrastructure


Please take backup of existing pages in QA before replacing QA page with Files in the location.
Please take a backup of below mentioned Procedures in QA.
  1. NE_ECALC_REPORT
  2. GET_SELECTED_TAPES
  3. INSERT_NEW_TAPE_ROW
  4. CHECK_TAPE_EXISTS_TODAY
  5. UPDATE_TAPE_RATES

Run the Date Change script.sql Script on QA DB
Move CaluclateEMBRuntype pages into MasterData folder of the application

For Requestor

Interface Changes

 Type
 Name
 Change
1
 Page
 CaluclateEMBRuntype.aspx
  1. Added a calender control for effective date input.
2
 Stored Procedure
 NE_ECALC_REPORT
 1. Updated the stored procedure to accept effective date from the front end.
3
 Stored Procedure
 GET_SELECTED_TAPES
 1. Updated the stored procedure to accept effective date from the front end.
4
 Stored Procedure
 INSERT_NEW_TAPE_ROW
 1. Updated the stored procedure to accept effective date from the front end.
5
 Stored Procedure
 CHECK_TAPE_EXISTS_TODAY
 1. Updated the stored procedure to accept effective date from the front end.
6
 Stored Procedure
 UPDATE_TAPE_RATES
 1. Updated the stored procedure to accept effective date from the front end.

Test Notes

Title
 Module
 Steps
 Expected Result
Calculate Embroidery Rates
 Calculate Embroidery Rates
 1. User should be able to access POLCA application.
2. Select Calculate Embroidery rates tab.
3. User should be able to see Drop down for Run type and
a Calender control for Effective date.
4. Enter Run type , Effective date and Embroidery Machine type.
5. Click on Run Button.
 When the ECALC Process is executed Effective date in
the PS_NEC_EMB_TAPES Table should be updated with
the effective date given in front end(Calender control).
ECALC Package
 ECALC Package
 1. Execute Wilcomm2Pending.dtsx, ECALC.dtsx package
 In this process effective date is updated with current date + 1
in PS_NEC_EMB_TAPES Table.

Reference Document (Specifications or Production Support Break Fix)

2013-02-26 - 4257.100 - Spec - ECALC Process rate change